SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:This beautifully renovated 3-bedroom, 3-bath split-level home offers the perfect blend of modern updates and an unbeatable Hanover location. Thoughtfully redesigned from top to bottom, the property features all-new siding, roof, windows, central air conditioning, and stylishly updated kitchen and baths. Bright, comfortable living spaces and a versatile floor plan make everyday living and entertaining effortless. Set in a sought-after neighborhood within easy walking distance to the highly acclaimed Hanover elementary and middle schools, this turnkey home combines quality, convenience, and timeless appeal.
Description:Set in a highly sought-after location with easy access to town and nearby trails, this beautifully maintained cape blends comfort, functionality, and convenience. An attached 2-car garage and direct entry add to the home’s everyday ease. Inside, the thoughtfully designed layout begins with a spacious mudroom featuring a walk-in closet and half bath—perfect for staying organized year-round. The open-concept kitchen, dining, and living area creates a natural gathering space, ideal for both daily living and entertaining, with a slider leading out to a private back patio. A dedicated home office offers the flexibility today’s buyers are looking for. Upstairs, you’ll find two generously sized bedrooms and a full bath, along with an oversized primary suite. This inviting retreat features a walk-in closet and an en-suite bath complete with a soaking tub. Convenient second-floor laundry enhances the home’s practical design. The finished lower level provides additional living space with a large family room and full window—perfect for guests, a media room, or a cozy place to unwind. A utility room offers excellent storage or the potential for a small workshop. All of this is just minutes from Dartmouth College and within 10 minutes of Dartmouth-Hitchcock Medical Center. With a level, low-maintenance yard and well manicured perennial gardens, and a location that balances accessibility with outdoor recreation, this home delivers the best of Upper Valley living.
Description:Set on a picturesque 7-acre parcel complete with a beautiful pond perfect for summer swimming and winter skating, this spacious four-bedroom contemporary offers the ideal balance of privacy and convenience just 10 minutes from downtown Hanover and Dartmouth Health. A substantial addition completed in 1990 transformed the home with a stunning open-concept family room featuring soaring ceilings, abundant natural light, an inviting gathering space designed for everyday living and entertaining alike. Above, the spacious primary suite provides a wonderful retreat with a soaking tub and private balcony overlooking the rolling pastures of Dartmouth's, Morton Horse Farm. Additional highlights include a large 4 season porch, a private back deck, a large finished basement offering exceptional flexibility for recreation, hobbies, fitness, and plenty of storage and separate two-bay garage. Call for a showing appt. or come to the Open House on Thursday (5/21) from 1-3.
Description:Terrific 5-bedroom, 3.5-bath Colonial nestled at the end of a quiet cul-de-sac in the highly sought-after Poverty Lane section of Lebanon. Surrounded by gardens you truly have to see to believe, the property offers a rare blend of beauty in a great location. Inside, a family room with fireplace leads into a great gourmet kitchen. Additionally, the living spaces features a formal dining room and living room. The spacious and private primary suite has a walk-in closet and an updated bathroom. Upstairs, you’ll find four additional bedrooms, two full bathrooms, and a dedicated office, offering flexible space for work or study. This house has spaces designed for both wellness and fun with a workout room in the walkout lower level and and an indoor saltwater pool, and hot tub. A unique opportunity to own a peaceful, elegant home in one of Lebanon’s most desirable neighborhoods. Showings by Open Houses - Friday 5/1 3-4:30, Satuday 5/2 11-1 and Sunday, 5/3 2-3:30.
Description:Wonderful contemporary home with 73+/-ac and majestic views from every window. Privately sited and with three very pretty ponds, there are several useful outbuildings to house animals or outdoor equipment as well as great indoor storage for sports equipment, skis, etc. With 3 bedrooms, 2 baths and a wonderful open floor plan, the property is close to the Green Woodlands ski/mountain biking/hiking trails, the Appalachian Trail, Dartmouth Skiway, boating on Reservoir Pond, and the charming village of Lyme. Just 30 minutes from Hanover, NH, Dartmouth College and Dartmouth Hitchcock Medical Center. A one-of-a-kind spot!